Re: [GENERAL] how to use COPY within plperl

Goutam Paruchuri wrote:
> Why can you not use simple insert statements (sql insert).
> Copy is meant to transfer large amount of data from text files to
> databases and vice versa.
"Insert" is much slower if there are many (hundreds, thousands) data to
be inserted - and in my case there will be thousands of inserts made by
plperl. I can make a file with the data (and load using COPY), but it
would be better to use copy from stdin.

Thanks

ML



---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

http://archives.postgresql.org
newsy [ Mo, 08 November 2004 20:14 ] [ ID #474013 ]
Datenbanken » comp.databases.postgresql.sql » Re: [GENERAL] how to use COPY within plperl

Vorheriges Thema: Job opportunity
Nächstes Thema: Hi